Appendix A — Appendix: Data Review and Uplift

Published

April 17, 2023

A.1 Introduction

Prior to publishing analysis and interpretation of water quality data, we will ensure that all data that meets QA/QC standards outlined in the current project Quality Assurance Project Plan (QAPP) and is accessible in the appropriate repository.

Water quality data from this project is ultimately destined for the Environmental Protection Agency’s Water Quality Exchange (EPA WQX). The process of transferring these data to the higher-level EPA repository is referred to as data “uplift.”

The Quality Assurance Project Plan (QAPP) for this project describes data management details and responsible parties for each step of the data pipeline from observation to repository. The 2021 data preparation and review process is published here as an appendix as an example of the process applied annually to each year’s data.

A.1.1 2021 Water Quality Data

In this appendix we will collate 2021 laboratory data from several sources into a single spreadsheet document with a consistent format. The desired end format is a spreadsheet template provided by the EPA Water Quality Exchange. These template files are available to download from the EPA at https://www.epa.gov/waterdata/water-quality-exchange-web-template-files.

Once the data is collated, it will be evaluated according to a Quality Assurance Checklist (template example provided by the Alaska Department of Environmental Conservation Soldotna office). Field observations that do not meet the quality assurance standards described in the evaluation checklist will be flagged and will not be uplifted to the EPA WQX.

Data that has been uplifted to the EPA WQX is evaluated biannually by the Alaska Department of Environmental Conservation (ADEC) in their Integrated Water Quality Monitoring and Assessment Report1. The integrated report evaluates available water quality data from the previous five years against Alaska water quality standards and regulations (ADEC 2020).

A.1.1.1 2021 Water Quality Data AQWMS Formatting

The code scripts below assemble water quality data from the three analytical laboratories that partnered with Kenai Watershed Forum for this project in 2021:

  • SGS Laboratories (Anchorage, AK)

  • Soldotna Wastewater Treatment Plant (Soldotna, AK)

  • Taurianen Engineering and Testing (Soldotna, AK)



A.1.1.1.1 2021 Metals/Nutrients Lab Results (SGS Labs)

*Note: the chain of custody documents for SGS Laboratories are integrated into the above downloadable PDF files.



A.1.1.1.2 2021 Fecal Coliform Lab Results (Soldotna Wastewater Treatment Plant (SWWTP)/Taurianen Engineering)


A.1.1.1.3 2021 Total Suspended Solids Lab Results (Soldotna Wastewater Treatment Plant (SWWTP))



A.1.2 2021 Provisional Results, Prior to Data Review

Results last updated 2023-04-17

The above data sources have been collated in to a single .csv file (available for download) into a format compatible with the EPA Water Quality Exchange. These data have not yet been evaluated against QA/QC standards following guidance in the current project Quality Assurance Project Plan.



A.1.3 2021 Data QA/QC Evaluation

Prior to uplift to the EPA WQX, all water quality data must be checked against a series of standard questions in order to evaluate how quality assurance / quality check (QA/QC) requirements are met. The draft Data Evaluation Checklist Template (available for download below) outlines these questions:

A.1.3.1 Pre-Database


A.1.3.1.1 Overall Project Success

1.) Were the appropriate analytical methods used for all parameters?

Yes. Analytical methods from the approved 2020 QAPP were employed.


2.) Were field duplicates, blanks, and/or other QC samples collected as planned?

`summarise()` has grouped output by 'analysis', 'expected_results',
'activity_start_date'. You can override using the `.groups` argument.
result_analytical_method_id activity_start_date activity_type expected_results_n actual_results_n pct_diff
200.7 2021-05-11 Quality Control Field Replicate Msr/Obs 6 3 -33.33333
200.7 2021-05-11 Field Msr/Obs 66 39 -25.71429
200.7 2021-07-27 Quality Control Field Replicate Msr/Obs 6 6 0.00000
200.7 2021-07-27 Field Msr/Obs 66 66 0.00000
200.8 2021-05-11 Quality Control Field Replicate Msr/Obs 6 6 0.00000
200.8 2021-05-11 Field Msr/Obs 72 132 29.41176
200.8 2021-07-27 Quality Control Field Replicate Msr/Obs 6 27 63.63636
200.8 2021-07-27 Field Msr/Obs 72 324 63.63636
2540-D 2021-05-11 Quality Control Field Replicate Msr/Obs 2 2 0.00000
2540-D 2021-05-11 Field Msr/Obs 22 22 0.00000
2540-D 2021-07-27 Quality Control Field Replicate Msr/Obs 2 2 0.00000
2540-D 2021-07-27 Field Msr/Obs 22 22 0.00000
4500-NO3(F) 2021-05-11 Quality Control Field Replicate Msr/Obs 2 2 0.00000
4500-NO3(F) 2021-05-11 Field Msr/Obs 22 22 0.00000
4500-NO3(F) 2021-07-27 Quality Control Field Replicate Msr/Obs 2 2 0.00000
4500-NO3(F) 2021-07-27 Field Msr/Obs 22 22 0.00000
4500-P-E 2021-05-11 Quality Control Field Replicate Msr/Obs 2 2 0.00000
4500-P-E 2021-05-11 Field Msr/Obs 22 22 0.00000
4500-P-E 2021-07-27 Quality Control Field Replicate Msr/Obs 2 2 0.00000
4500-P-E 2021-07-27 Field Msr/Obs 22 22 0.00000
8260D 2021-07-27 Field Msr/Obs 24 24 0.00000
8260D 2021-07-27 Quality Control Sample-Trip Blank 24 24 0.00000
9222D 2021-05-11 Quality Control Field Replicate Msr/Obs 2 2 0.00000
9222D 2021-05-11 Field Msr/Obs 22 22 0.00000
9222D 2021-07-27 Quality Control Field Replicate Msr/Obs 2 2 0.00000
9222D 2021-07-27 Field Msr/Obs 22 22 0.00000


From the above table we can see that there are deviations between planned and actual results available. These reasons for the deviations are known and are attributable to two causes:

Cause 1: The Spring 2021 Chain of Custody (COC) from KWF to SGS was completed erroneously. The COC specified for 200.8 analyses to be complete for all sites (when they should have stopped upstream of Morgan’s Landing RM31), and it also specified for 200.7 analyses to stop upstream of Morgan’s Landing (when they should have been performed for all sites in the project).

As a result, for Spring 2021 total metals data will be unavailable for sites upstream of Morgan’s Landing RM31.

Cause 2: For Summer 2021, the SGS performed the 200.8 analyses for all 27 analytes available for the method; instead of just the smaller subset of analytes. (E.g., KWF received extra data for free, no consequences of deviating from planned analyses).


3.) Do the laboratory reports provide results for all sites and parameters?

Analysis in progress here as of 4-14-2023


  1. https://dec.alaska.gov/water/water-quality/integrated-report/↩︎